HARSH LARIYA

DATA SCIENCE AND BUSINESS ANALYTICS INTERN @ THE SPARKS FOUNDATION

#GRIPJUNE21 #TSF #DATASCIENCE

EXPLORATORY DATA ANALYSIS - RETAIL

Problem statement:As a business manager, try to find out the weak areas where you can work to make more profit.

1.IMPORTING LIBRARIES

2.LOADING DATASET

CHECKING NULL VALUES AND BASIC ANALYSIS OF DATASET

EXPLORATORY DATA ANAYSIS

ANALYSIS USING PAIRPLOTS

Profit is more than that of sales and sales is widely spread

COUNT PLOTS

Most used Ship Mode : Standard Class Least used Ship Mode: Same Day

Region with most count : West Region with most count : South

CORRELATION

DISTRIBUTION

STATE WISE ANALYSIS

Top 3 state where Profits are Highest: Califonia New York Washington

Top 3 state where Profits are Lowest: Texas Ohio Pennsylvania

Top 3 state where Sales are Highest. California New York Texas

Top 3 state where Sales are Lowest. North Dakota West Virginia Maine

States with highest amount of sales = Wyoming,Vermont,Nevada States with lowest amount of sales = South Dakota,Kansas,South Carolina

CITY wise

Segment wise analysis of Profit, Discount and sell

QUANTITY WISE SALES, PROFIT AND DISCOUNT ANALYSIS

SUB CATEGORY WISE

CATEGORY WISE

REGION WISE

ship mode wise

RESULT AND CONCLUSION

Profit is more than that of sales and sales is widely spread.

Most widely used Ship Mode is Standard Class and the least is Same Day.

Most orders are from West region and the least is from South Region.

Consumer segment bought most products while Home offices bought the least.

Most sold Category is office supplies and the least is Technology.

Most sold Sub Categories : Binders, Paper, Furnishings.

Least sold Sub Categories: Copiers, Machines, Supplies.

Maximum people did not get discount while the minimum people got discount of 0.45.

Most ordered category is Office Supplies and the least ordered is Technology.

Most sold item in each category :

Furniture - furnishings.

Office supplies - Binders.

Technology - Phones.

Least sold item in each category :

Furniture - Bookcases.

Office supplies - Supplies.

Technology - Machines.

Most sold item is Binders in West and the least is Copiers in South.

Correlations:

Sales and Profit are Moderately Correlated.

Quantity and Profit are less Moderately Correlated.

Discount and Profit are Negatively Correlated

States wise Analysis :

States with most Profit : California, New York, Washington.

States with least Profit: Texas, Ohio, Pennsylvania.

States with most sales : California, New York, Texas.

States with least sales: Wyoming, West Virginia, North Dakota.

States with most Discount : Texas, Pennsylvania, Illinois.

States with least Discount: Alabama, Missouri, Maine and 22 other.

Mean sales is maximum for Wyoming and least for South Dakota.

City Wise Analysis:

Cities with maximum number of counts: New York City, Los Angeles, Philadelphia.

Cities with minimum number of counts: Commerce City, Aberdeen, Orland Park.

Cities with maximum Profit: New York City, Los Angeles, Seattle.

Cities with minimum Profit: Philadelphia, Houston, San-Antonio.

Cities with maximum Sales: New York City, Los Angeles, Seattle.

Cities with minimum Sales: Abilene, Elyria, Jupiter.

Segment wise Analysis: Maximum sales and profit are from Home Offices while the least is Consumer segment.

Quantity wise Analysis: Most people bought items in a triplet (20%) and least people bought 12(0.4%) and more.

Sub Category wise Analysis :

Most sold Category : Phones(14.4%), Chairs(14.3%), Storage(9.7%). Least sold Category : Fasteners, Labels, Envelopes.

Most Profitable Category : Copies, Phones, Accessories.

Least Profitable Category: Tables, Bookcases, Supplies.

Tables and bookcases are most sold but with the least profit.

Binders are the most sold item in every region.

Most discounts are on binders and the least is on copier.

Technology has most profit and sales.

Region Wise Analysis : West region has highest number of sales and high Profit . Central Region has lowest Profit. South Region Has the lowest Sales.